MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Artist Alpha Sort = 8482

View and edit SQL

Suggested facets: Department, Object Name, Artist Role, Artist Prefix, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
101763 07.196 0 1 189283 European Sculpture and Decorative Arts 3 Statuette 14 Kneeling Madonna Italian, Florence 1136         Artist 2   Giovanni della Robbia Italian, Florence 1469–1529/30 Florence   della Robbia, Giovanni 8482 Italian 6 1469 1530 ca. 1490–1500 1485 1505 Terracotta, partially glazed and gilded 20816 Height: 16 1/2 in. (41.9 cm) Rogers Fund, 1907                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
105016 14.23a–d 0 1 192684 European Sculpture and Decorative Arts 3 Group 3937 Pietà Italian, Florence 1136         Artist 2 Workshop of Giovanni della Robbia Italian, Florence 1469–1529/30 Florence   della Robbia, Giovanni 8482 Italian 6 1469 1530 early 16th century 1500 1515 Terracotta, painted 21150 Overall: 40 1/2 × 67 3/8 in. (102.9 × 171.1 cm) Frederick C. Hewitt Fund, 1913                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
105195 14.64.1 0 1 192904 European Sculpture and Decorative Arts 3 Vase 7 Vase Italian, Florence 1136         Maker 1   Giovanni della Robbia Italian, Florence 1469–1529/30 Florence   della Robbia, Giovanni 8482 Italian 6 1469 1530 ca. 1500 1495 1505 Glazed terracotta 20493 Overall (confirmed): 12 1/4 x 11 1/4 x 8 15/16 in. (31.1 x 28.6 x 22.7 cm) Rogers Fund, 1914                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
105784 17.190.743 0 1 193620 European Sculpture and Decorative Arts 3 Tondo 7601 Minerbetti coat of arms Italian, Florence 1136         Artist 2 Workshop of Giovanni della Robbia Italian, Florence 1469–1529/30 Florence   della Robbia, Giovanni 8482 Italian 6 1469 1530 ca. 1510 1505 1515 Glazed terracotta 20493 wt. confirmed: 22 1/2 × 22 1/2 in., 38 lb. (57.2 × 57.2 cm, 17.2 kg) Gift of J. Pierpont Morgan, 1917                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
106164 17.190.1408 0 1 194002 European Sculpture and Decorative Arts 3 Bust 5 Boy Saint John Italian, Florence 1136         Artist 2   Giovanni della Robbia Italian, Florence 1469–1529/30 Florence   della Robbia, Giovanni 8482 Italian 6 1469 1530 15th–16th century 1400 1599 Terracotta, enamelled and painted 21500 Height: 14 3/8 in. (36.5 cm) Gift of J. Pierpont Morgan, 1917                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
106678 18.70.26 0 1 194523 European Sculpture and Decorative Arts 3 Bust 5 Saint Antonino, Dominican Archbishop of Florence (b. 1389, archbishop 1446, d. 1459) Italian, Florence 1136         Artist 2 Manner of Giovanni della Robbia Italian, Florence 1469–1529/30 Florence   della Robbia, Giovanni 8482 Italian 6 1469 1530 first half 16th century 1500 1550 Carta Pesta, painted 21659 Height: 18 in. (45.7 cm) Rogers Fund, 1918                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
108984 32.100.150 0 1 197028 European Sculpture and Decorative Arts 3 Relief 3917 Madonna and Child Italian, Florence 1136         Artist 2 Probably workshop of Giovanni della Robbia Italian, Florence 1469–1529/30 Florence   della Robbia, Giovanni 8482 Italian 6 1469 1530 early 16th century 1500 1515 Glazed terracotta 20493 28 1/4 × 17 3/4 in. (71.8 × 45.1 cm) The Friedsam Collection, Bequest of Michael Friedsam, 1931                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
110719 41.190.43 0 1 198921 European Sculpture and Decorative Arts 3 Armorial tondo 7670 Armorial tondo Italian, Florence 1136         Maker 1 School of Giovanni della Robbia Italian, Florence 1469–1529/30 Florence   della Robbia, Giovanni 8482 Italian 6 1469 1530 15th–16th century 1400 1599 Painted and glazed terracotta 22274 Diameter: 27 in. (68.6 cm) Bequest of George Blumenthal, 1941                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
110720 41.190.44 0 1 198922 European Sculpture and Decorative Arts 3 Armorial tondo 7670 Armorial Tondo with the Arms of Squarci Lupi Italian, Florence 1136         Maker 1 School of Giovanni della Robbia Italian, Florence 1469–1529/30 Florence   della Robbia, Giovanni 8482 Italian 6 1469 1530 15th–16th century 1400 1599 Painted and glazed terracotta 22274 Diameter: 27 in. (68.6 cm) Bequest of George Blumenthal, 1941                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
322300 1975.1.2039 0 1 460458 Robert Lehman Collection 16 Tondo 7601 Tondo           Artist 2 Workshop of Giovanni della Robbia Italian, Florence 1469–1529/30 Florence   della Robbia, Giovanni 8482 Italian 6 1469 1530 ca. 1500–1520 1497 1523 Tin-glazed terracotta 48329 Diam. 57.5 cm Robert Lehman Collection, 1975                       Sculpture-Terracotta 795   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 137.862ms · Data license: CC0 · Data source: metmuseum/openaccess